Excel 2019 - Autofill and Paste Options, Proofing Tools, Flash Fill and Macro
      This course is part of the MOS exam 77-727 range that will teach you the essential skills to successfully pass the Microsoft Office Specialist (MOS) certification exam. In this course you will learn about AutoFill and Paste Options. You will also learn about Proofing Tools, Flash Fill and Macros.      
      AutoFill and Paste Options      
      Upon successful completion you will be able to:

1. Use AutoFill;
2. Use Paste Options;
3. Perform Operations with Paste Special;
4. Copy Formatting with Paste Special.		      
      Proofing Tools      
      Upon successful completion you will be able to:

1. Modify Error Checking Settings;
2. Use the Error Checking Tool;
3. Spell Check Worksheets;
4. Use AutoComplete to Enter Data;
5. Use AutoCorrect;
6. Work with AutoCalculate.
      
      Flash Fill and Macros      
      Upon successful completion you will be able to:

1. Use Flash Fill;
2. Understand Macros;
3. Record Macros;
4. Assign Shortcut Keys to Macros;
5. Run Macros;
6. Add QAT buttons;
7. Change Button Icons;
8. Display Shortcut Keys;
9. Modify Macro Security Settings.
      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2019 - Autofill and Paste Options, Proofing Tools, Flash Fill and Macro :
Program Training Courses - Microsoft Excel 2019 :
Office Suite Training Courses - Microsoft Office 2019 / Office 365 :
© 2020 Online Training Masters